{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Cover","Contents","Assumptions_SC","TS_BA","Rev_TA","Outputs_SC","Rev_TO","Appendices_SC","Lookup_Tables_SSC","TS_LU","Checks_SSC","Checks_BO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":219,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,2,10,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Best Practice Modelling"]
[null,null,{"$f":"\"SMA 15. Visual Basic Programming - Best Practice Model Example\"&Err_Chks_Msg&Sens_Chks_Msg&Alt_Chks_Msg","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  BPM"]
[]
[null,null,"Cover Notes:"]
[null,null,"-","Provides a basic example of best practice VBA programming."]
[null,null,"-","Use of this model is subject to the training model terms and conditions on the Best Practice Modelling website."]

{"sheet":"Contents","index":1,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,8,19,15],[2,1,2,8],[16,5,16,6],[16,7,16,15],[17,8,17,15],[18,8,18,15],[7,1,7,2],[7,3,7,15],[8,5,8,6],[8,7,8,15],[15,3,15,4],[15,5,15,15],[10,1,10,2],[10,3,10,15],[11,5,11,6],[11,7,11,15],[12,1,12,2],[12,3,12,15],[9,5,9,6],[9,7,9,15],[13,3,13,4],[13,5,13,15],[14,5,14,6],[14,7,14,15]]}
[null,"Table of Contents"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Cover Sheet"]
[]
[]
["é","Section & Sheet Titles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Page  "]
[]
[null,1,null,{"$f":"Assumptions_SC!C9","v":"Assumptions"},null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,"a.",null,{"$f":"TS_BA!B1","v":"Time Series Assumptions"},null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,"b.",null,{"$f":"Rev_TA!B1","v":"Revenue Assumptions"},null,null,null,null,null,null,null,null,5]
[null,2,null,{"$f":"Outputs_SC!C9","v":"Outputs"},null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,"a.",null,{"$f":"Rev_TO!B1","v":"Revenue Outputs"},null,null,null,null,null,null,null,null,7]
[null,3,null,{"$f":"Appendices_SC!C9","v":"Appendices"},null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,"3.1.",null,{"$f":"Lookup_Tables_SSC!C9","v":"Lookup Tables"},null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,"a.",null,{"$f":"TS_LU!B1","v":"Time Series Lookup Tables"},null,null,null,null,null,null,null,null,10]
[null,null,null,"3.2.",null,{"$f":"Checks_SSC!C9","v":"Checks"},null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,"a.",null,{"$f":"Checks_BO!B1","v":"Checks"},null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,"-",{"$f":"TOC_Hdg_3","v":"Error Checks"},null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,"-",{"$f":"TOC_Hdg_4","v":"Sensitivity Checks"},null,null,null,null,null,null,null,"-"]
[null,null,null,null,null,null,null,"-",{"$f":"TOC_Hdg_5","v":"Alert Checks"},null,null,null,null,null,null,null,"-"]
[]
[null,"Total Pages:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]

{"sheet":"Assumptions_SC","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Assumptions"]
[null,null,"Section 1."]
[null,null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Section Cover Notes:"]
[null,null,"[Insert section cover note 1]"]
[null,null,"[Insert section cover note 2]"]
[null,null,"[Insert section cover note 3]"]

{"sheet":"TS_BA","index":3,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[55,9,55,10],[56,9,56,10],[57,9,57,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[45,9,45,10],[25,9,25,10],[26,9,26,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[2,1,2,5],[10,9,10,10],[11,9,11,10],[24,9,24,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10]]}
[null,"Time Series Assumptions"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Table of Contents"]
["é","ç","è","x","h","O"]
[]
[]
[null,"Time Series Assumptions"]
[]
[null,null,"Core Time Series Assumptions"]
[]
[null,null,null,"Title",null,null,null,null,null,"Primary"]
[null,null,null,"Periodicity",null,null,null,null,null,{"$f":"Annual","v":"Annual"}]
[null,null,null,"Financial Year End",null,null,null,null,null,31,12]
[null,null,null,"Start Date",null,null,null,null,null,"2010-01-01"]
[null,null,null,"Periods",null,null,null,null,null,5]
[null,null,null,"Period Type",null,null,null,null,null,{"$f":"INDEX(LU_Period_Type_Names,MATCH(TS_Periodicity,LU_Periodicity,0))","v":"Year"}]
[null,null,null,"Period Type Prefix",null,null,null,null,null,{"$f":"CHOOSE(MATCH(TS_Periodicity,LU_Periodicity,0),Yr_Name,\"H\",\"Q\",\"M\")","v":"Year"}]
[null,null,null,"Financial Year End Is Month End?",null,null,null,null,null,{"$f":"OR(AND(DD_TS_Fin_YE_Day>=28,DD_TS_Fin_YE_Mth=2),\nDD_TS_Fin_YE_Day>=DAY(EOMONTH(DATE(YEAR(TS_Start_Date),DD_TS_Fin_YE_Mth,1),0)))","v":true}]
[null,null,null,"First Period Financial Year Start Date",null,null,null,null,null,{"$f":"IF(TS_Mth_End,DATE(YEAR(TS_Per_1_FY_End_Date)-IF(TS_Per_1_FY_End_Date=EOMONTH(DATE(YEAR(TS_Per_1_FY_End_Date),Mths_In_Yr,1),0),0,1),MOD(MONTH(TS_Per_1_FY_End_Date),Mths_In_Yr)+1,1),\nEDATE(TS_Per_1_FY_End_Date,-Mths_In_Yr)+1)","v":"2010-01-01"}]
[null,null,null,"First Period Financial Year End Date",null,null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(DATE(YEAR(TS_Start_Date)+IF(MONTH(TS_Start_Date)>DD_TS_Fin_YE_Mth,1,0),DD_TS_Fin_YE_Mth,1),0),\nDATE(YEAR(TS_Start_Date)+IF(TS_Start_Date>DATE(YEAR(TS_Start_Date),DD_TS_Fin_YE_Mth,DD_TS_Fin_YE_Day),1,0),DD_TS_Fin_YE_Mth,DD_TS_Fin_YE_Day))","v":"2010-12-31"}]
[null,null,null,"Periods In Year",null,null,null,null,null,{"$f":"INDEX(LU_Pers_In_Yr,MATCH(TS_Periodicity,LU_Periodicity,0))","v":1}]
[null,null,null,"Months In Period",null,null,null,null,null,{"$f":"Mths_In_Yr/TS_Pers_In_Yr","v":12}]
[null,null,null,"First Period Financial Period Number",null,null,null,null,null,{"$f":"INT((((YEAR(TS_Start_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Start_Date)-MONTH(TS_Per_1_FY_Start_Date)+1\n+IF(TS_Mth_End,0,\nIF(TS_Start_Date>(EDATE(TS_Per_1_FY_Start_Date,(YEAR(TS_Start_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Start_Date)-MONTH(TS_Per_1_FY_Start_Date)+1)-1),1,0)\n-IF(TS_Start_Date<EDATE(TS_Per_1_FY_Start_Date,(YEAR(TS_Start_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Start_Date)-MONTH(TS_Per_1_FY_Start_Date)),1,0)))-1)/TS_Mths_In_Per)+1","v":1}]
[null,null,null,"First Period Start Date (If Full Period)",null,null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number-1)*TS_Mths_In_Per-1),0)+1,\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number-1)*TS_Mths_In_Per))","v":"2010-01-01"}]
[null,null,null,"First Period End Date",null,null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,TS_Per_1_Number*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,TS_Per_1_Number*TS_Mths_In_Per)-1)","v":"2010-12-31"}]
[null,null,null,"Denomination",null,null,null,null,null,2]
[null,null,null,"Denomination Label",null,null,null,null,null,{"$f":"INDEX(LU_Denom,DD_TS_Denom)","v":"$Millions"}]
[]
[null,null,"Historical & Forecast Period Titles"]
[]
[null,null,null,"Include in Period Titles?",null,null,null,null,null,true]
[null,null,null,"Actual Periods",null,null,null,null,null,3]
[null,null,null,"Budget Periods",null,null,null,null,null,0]
[null,null,null,"Historical / Actual Periods Title",null,null,null,null,null,"(A)"]
[null,null,null,"Budget Periods Title",null,null,null,null,null,"(B)"]
[null,null,null,"Forecast Period Title",null,null,null,null,null,"(F)"]
[]
[null,null,"Data & Projections - Timing Assumptions"]
[]
[null,null,null,"Data Term Basis",null,null,null,null,null,1]
[null,null,null,"Data - Active Periods",null,null,null,null,null,3]
[null,null,null,"Projections - Start Date",null,null,null,null,null,"2013-01-01"]
[]
[null,null,null,"Data Time Series Sheets"]
[]
[null,null,null,null,"Data End Date",null,null,null,null,{"$f":"TS_Proj_Start_Date-1","v":"2012-12-31"}]
[null,null,null,null,"Total Data Periods",null,null,null,null,{"$f":"IF(TS_Data_End_Date<TS_Start_Date,0,\nMAX(0,INT((((YEAR(TS_Data_End_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Data_End_Date)-MONTH(TS_Per_1_FY_Start_Date)+1\n+IF(TS_Mth_End,0,\nIF(TS_Data_End_Date>(EDATE(TS_Per_1_FY_Start_Date,(YEAR(TS_Data_End_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Data_End_Date)-MONTH(TS_Per_1_FY_Start_Date)+1)-1),1,0)\n-IF(TS_Data_End_Date<EDATE(TS_Per_1_FY_Start_Date,(YEAR(TS_Data_End_Date)-YEAR(TS_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Data_End_Date)-MONTH(TS_Per_1_FY_Start_Date)),1,0)))\n-1)/TS_Mths_In_Per)-TS_Per_1_Number+2))","v":3}]
[null,null,null,null,"Full Data Periods",null,null,null,null,{"$f":"IF(TS_Data_Total_Pers=0,0,\nTS_Data_Total_Pers-IF(TS_Data_End_Date<>IF(TS_Data_Total_Pers=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Total_Pers-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Total_Pers-1)*TS_Mths_In_Per)-1)),1,0))","v":3}]
[null,null,null,null,"Final Data Period Is Stub",null,null,null,null,{"$f":"IF(TS_Data_End_Date<TS_Start_Date,FALSE,\nIF(TS_Data_End_Date=TS_Per_1_End_Date,IF(TS_Start_Date<>TS_Per_1_Start_Date,TRUE,FALSE),\nIF(TS_Data_End_Date<TS_Per_1_End_Date,TRUE,\nIF(TS_Data_End_Date<>IF(TS_Data_Total_Pers=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Total_Pers-1)*TS_Mths_In_Per-1),0),EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Total_Pers-1)*TS_Mths_In_Per)-1)),TRUE,FALSE))))","v":false}]
[]
[null,null,null,"Projections Time Series Sheets"]
[]
[null,null,null,null,"Projections Start Date",null,null,null,null,{"$f":"IF(DD_TS_Data_Term_Basis=1,IF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Pers_Ass-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+TS_Data_Pers_Ass-1)*TS_Mths_In_Per)-1)+1,TS_Proj_Start_Date_Ass)","v":"2013-01-01"}]
[null,null,null,null,"First Period Financial Year Start Date",null,null,null,null,{"$f":"IF(TS_Mth_End,DATE(YEAR(TS_Proj_Per_1_FY_End_Date)-IF(TS_Proj_Per_1_FY_End_Date=EOMONTH(DATE(YEAR(TS_Proj_Per_1_FY_End_Date),Mths_In_Yr,1),0),0,1),MOD(MONTH(TS_Proj_Per_1_FY_End_Date),Mths_In_Yr)+1,1),\nEDATE(TS_Proj_Per_1_FY_End_Date,-Mths_In_Yr)+1)","v":"2013-01-01"}]
[null,null,null,null,"First Period Financial Year End Date",null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(DATE(YEAR(TS_Proj_Start_Date)+IF(MONTH(TS_Proj_Start_Date)>DD_TS_Fin_YE_Mth,1,0),DD_TS_Fin_YE_Mth,1),0),\nDATE(YEAR(TS_Proj_Start_Date)+IF(TS_Proj_Start_Date>DATE(YEAR(TS_Proj_Start_Date),DD_TS_Fin_YE_Mth,DD_TS_Fin_YE_Day),1,0),DD_TS_Fin_YE_Mth,DD_TS_Fin_YE_Day))","v":"2013-12-31"}]
[null,null,null,null,"First Period Financial Period Number",null,null,null,null,{"$f":"INT((((YEAR(TS_Proj_Start_Date)-YEAR(TS_Proj_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Proj_Start_Date)-MONTH(TS_Proj_Per_1_FY_Start_Date)+1\n+IF(TS_Mth_End,0,\nIF(TS_Proj_Start_Date>(EDATE(TS_Proj_Per_1_FY_Start_Date,(YEAR(TS_Proj_Start_Date)-YEAR(TS_Proj_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Proj_Start_Date)-MONTH(TS_Proj_Per_1_FY_Start_Date)+1)-1),1,0)\n-IF(TS_Proj_Start_Date<EDATE(TS_Proj_Per_1_FY_Start_Date,(YEAR(TS_Proj_Start_Date)-YEAR(TS_Proj_Per_1_FY_Start_Date))*Mths_In_Yr+MONTH(TS_Proj_Start_Date)-MONTH(TS_Proj_Per_1_FY_Start_Date)),1,0)))\n-1)/TS_Mths_In_Per)+1","v":1}]
[null,null,null,null,"First Period Start Date (If Full Period)",null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(EDATE(TS_Proj_Per_1_FY_Start_Date,(TS_Proj_Per_1_Number-1)*TS_Mths_In_Per-1),0)+\n1,EDATE(TS_Proj_Per_1_FY_Start_Date,(TS_Proj_Per_1_Number-1)*TS_Mths_In_Per))","v":"2013-01-01"}]
[null,null,null,null,"First Period End Date",null,null,null,null,{"$f":"IF(TS_Mth_End,EOMONTH(EDATE(TS_Proj_Per_1_FY_Start_Date,TS_Proj_Per_1_Number*TS_Mths_In_Per-1),0),\nEDATE(TS_Proj_Per_1_FY_Start_Date,TS_Proj_Per_1_Number*TS_Mths_In_Per)-1)","v":"2013-12-31"}]
[]
[null,null,"Notes:"]
[null,null,"-","A Financial Year End assumption of 28th of February is assumed to be a month end financial year end, even in a leap year."]
[null,null,"-","The \"Model Denomination\" assumption will not necessarily automatically change the denomination of the outputs of this model."]
[null,null,"-","A \"Budget Period\" refers to either a period in the current financial year or periods containing combined actual and forecast data."]
[null,null,"-","\"Data & Projections - Timing Assumptions\" are used as the basis for related data and projections time series sheets."]
[null,null,"-","Use the bpmToolbox \"Update Time Series Columns\" tool to hide inactive data and projections time series periods."]

{"sheet":"Rev_TA","index":4,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,2,20,6],[21,2,21,6],[22,2,22,6],[23,2,23,6],[2,1,2,5],[18,2,18,6],[19,2,19,6]]}
[null,"Revenue Assumptions"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Table of Contents"]
["é","ç","è","x","h","O"]
[]
[null,{"$f":"IF(TS_Pers_In_Yr=1,\"\",TS_Per_Type_Name&\" Ending\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(J9)),3)&\"-\"&RIGHT(YEAR(J9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(K9)),3)&\"-\"&RIGHT(YEAR(K9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(L9)),3)&\"-\"&RIGHT(YEAR(L9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(M9)),3)&\"-\"&RIGHT(YEAR(M9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(N9)),3)&\"-\"&RIGHT(YEAR(N9),2))&\" \"","v":" "}]
[null,{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name&\" Ending \"&DAY(TS_Per_1_End_Date)&\" \"&INDEX(LU_Mth_Names,DD_TS_Fin_YE_Mth),TS_Per_Type_Name)","v":"Year Ending 31 December"},null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,J10&\" \",J11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(J12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(J12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2010 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,K10&\" \",K11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(K12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(K12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2011 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,L10&\" \",L11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(L12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(L12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2012 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,M10&\" \",M11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(M12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(M12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2013 (F) "},{"$f":"IF(TS_Pers_In_Yr=1,N10&\" \",N11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(N12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(N12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2014 (F) "}]
[null,"Period Start Date (From Start of Day...)",null,null,null,null,null,null,null,{"$f":"IF(J12=1,TS_Start_Date,I9+1)","v":"2010-01-01"},{"$f":"IF(K12=1,TS_Start_Date,J9+1)","v":"2011-01-01"},{"$f":"IF(L12=1,TS_Start_Date,K9+1)","v":"2012-01-01"},{"$f":"IF(M12=1,TS_Start_Date,L9+1)","v":"2013-01-01"},{"$f":"IF(N12=1,TS_Start_Date,M9+1)","v":"2014-01-01"}]
[null,"Period End Date (Until End of Day...)",null,null,null,null,null,null,null,{"$f":"IF(J12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+J12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+J12-1)*TS_Mths_In_Per)-1))","v":"2010-12-31"},{"$f":"IF(K12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+K12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+K12-1)*TS_Mths_In_Per)-1))","v":"2011-12-31"},{"$f":"IF(L12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+L12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+L12-1)*TS_Mths_In_Per)-1))","v":"2012-12-31"},{"$f":"IF(M12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+M12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+M12-1)*TS_Mths_In_Per)-1))","v":"2013-12-31"},{"$f":"IF(N12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+N12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+N12-1)*TS_Mths_In_Per)-1))","v":"2014-12-31"}]
[null,"Financial Year",null,null,null,null,null,null,null,{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+J12-2)/TS_Pers_In_Yr)","v":2010},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+K12-2)/TS_Pers_In_Yr)","v":2011},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+L12-2)/TS_Pers_In_Yr)","v":2012},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+M12-2)/TS_Pers_In_Yr)","v":2013},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+N12-2)/TS_Pers_In_Yr)","v":2014}]
[null,"Financial Year Period",null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+J12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+J12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+K12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+K12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+L12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+L12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+M12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+M12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+N12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+N12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "}]
[null,"Counter",null,null,null,null,null,null,null,{"$f":"COLUMN(J12)-COLUMN($J12)+1","v":1},{"$f":"COLUMN(K12)-COLUMN($J12)+1","v":2},3,4,5]
[null,"Period Key",null,null,null,null,null,null,null,{"$f":"J10&\"-\"&J11","v":"2010-Year "},{"$f":"K10&\"-\"&K11","v":"2011-Year "},"2012-Year ","2013-Year ","2014-Year "]
[]
[]
[null,{"$f":"B1&\" (\"&INDEX(LU_Denom,DD_TS_Denom)&\")\"","v":"Revenue Assumptions ($Millions)"}]
[]
[null,null,"Category"]
[null,null,"Apples",null,null,null,null,null,null,100,101,102,103,104]
[null,null,"Oranges",null,null,null,null,null,null,101,102,103,104,105]
[null,null,"Bananas",null,null,null,null,null,null,102,103,104,105,106]
[null,null,"Peaches",null,null,null,null,null,null,103,104,105,106,107]
[null,null,"Pears",null,null,null,null,null,null,104,105,106,107,108]
[null,null,"Plums",null,null,null,null,null,null,105,106,107,108,109]
[null,null,"Total",null,null,null,null,null,null,{"$f":"SUM(J19:J24)","v":615},{"$f":"SUM(K19:K24)","v":621},627,633,639]

{"sheet":"Outputs_SC","index":5,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Outputs"]
[null,null,"Section 2."]
[null,null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Section Cover Notes:"]
[null,null,"[Insert section cover note 1]"]
[null,null,"[Insert section cover note 2]"]
[null,null,"[Insert section cover note 3]"]

{"sheet":"Rev_TO","index":6,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[null,"Revenue Outputs"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Table of Contents"]
["é","ç","è","x","h","O"]
[]
[null,{"$f":"IF(TS_Pers_In_Yr=1,\"\",TS_Per_Type_Name&\" Ending\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(J9)),3)&\"-\"&RIGHT(YEAR(J9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(K9)),3)&\"-\"&RIGHT(YEAR(K9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(L9)),3)&\"-\"&RIGHT(YEAR(L9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(M9)),3)&\"-\"&RIGHT(YEAR(M9),2))&\" \"","v":" "},{"$f":"IF(TS_Pers_In_Yr=1,\"\",LEFT(INDEX(LU_Mth_Names,MONTH(N9)),3)&\"-\"&RIGHT(YEAR(N9),2))&\" \"","v":" "}]
[null,{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name&\" Ending \"&DAY(TS_Per_1_End_Date)&\" \"&INDEX(LU_Mth_Names,DD_TS_Fin_YE_Mth),TS_Per_Type_Name)","v":"Year Ending 31 December"},null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,J10&\" \",J11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(J12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(J12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2010 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,K10&\" \",K11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(K12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(K12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2011 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,L10&\" \",L11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(L12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(L12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2012 (A) "},{"$f":"IF(TS_Pers_In_Yr=1,M10&\" \",M11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(M12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(M12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2013 (F) "},{"$f":"IF(TS_Pers_In_Yr=1,N10&\" \",N11)&IF(CB_TS_Show_Hist_Fcast_Pers,IF(N12<=TS_Actual_Pers,TS_Actual_Per_Title,\nIF(N12<=TS_Actual_Pers+TS_Budget_Pers,TS_Budget_Per_Title,TS_Fcast_Per_Title))&\" \",\"\")","v":"2014 (F) "}]
[null,"Period Start Date (From Start of Day...)",null,null,null,null,null,null,null,{"$f":"IF(J12=1,TS_Start_Date,I9+1)","v":"2010-01-01"},{"$f":"IF(K12=1,TS_Start_Date,J9+1)","v":"2011-01-01"},{"$f":"IF(L12=1,TS_Start_Date,K9+1)","v":"2012-01-01"},{"$f":"IF(M12=1,TS_Start_Date,L9+1)","v":"2013-01-01"},{"$f":"IF(N12=1,TS_Start_Date,M9+1)","v":"2014-01-01"}]
[null,"Period End Date (Until End of Day...)",null,null,null,null,null,null,null,{"$f":"IF(J12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+J12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+J12-1)*TS_Mths_In_Per)-1))","v":"2010-12-31"},{"$f":"IF(K12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+K12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+K12-1)*TS_Mths_In_Per)-1))","v":"2011-12-31"},{"$f":"IF(L12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+L12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+L12-1)*TS_Mths_In_Per)-1))","v":"2012-12-31"},{"$f":"IF(M12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+M12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+M12-1)*TS_Mths_In_Per)-1))","v":"2013-12-31"},{"$f":"IF(N12=1,TS_Per_1_End_Date,\nIF(TS_Mth_End,EOMONTH(EDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+N12-1)*TS_Mths_In_Per-1),0),\nEDATE(TS_Per_1_FY_Start_Date,(TS_Per_1_Number+N12-1)*TS_Mths_In_Per)-1))","v":"2014-12-31"}]
[null,"Financial Year",null,null,null,null,null,null,null,{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+J12-2)/TS_Pers_In_Yr)","v":2010},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+K12-2)/TS_Pers_In_Yr)","v":2011},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+L12-2)/TS_Pers_In_Yr)","v":2012},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+M12-2)/TS_Pers_In_Yr)","v":2013},{"$f":"YEAR(TS_Per_1_FY_End_Date)+INT((TS_Per_1_Number+N12-2)/TS_Pers_In_Yr)","v":2014}]
[null,"Financial Year Period",null,null,null,null,null,null,null,{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+J12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+J12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+K12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+K12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+L12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+L12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+M12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+M12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "},{"$f":"IF(TS_Pers_In_Yr=1,Yr_Name,TS_Per_Type_Prefix&IF(MOD(TS_Per_1_Number+N12-1,TS_Pers_In_Yr)=0,TS_Pers_In_Yr,MOD(TS_Per_1_Number+N12-1,TS_Pers_In_Yr)))&\" \"","v":"Year "}]
[null,"Counter",null,null,null,null,null,null,null,{"$f":"COLUMN(J12)-COLUMN($J12)+1","v":1},{"$f":"COLUMN(K12)-COLUMN($J12)+1","v":2},3,4,5]
[null,"Period Key",null,null,null,null,null,null,null,{"$f":"J10&\"-\"&J11","v":"2010-Year "},{"$f":"K10&\"-\"&K11","v":"2011-Year "},"2012-Year ","2013-Year ","2014-Year "]
[]
[]
[null,{"$f":"B1&\" (\"&INDEX(LU_Denom,DD_TS_Denom)&\")\"","v":"Revenue Outputs ($Millions)"}]
[]
[null,null,{"$f":"Rev_TA!C18","v":"Category"}]
[null,null,{"$f":"Revenue_Category_1_Name","v":"Apples"},null,null,null,null,null,null,{"$f":"Rev_TA!J19","v":100},{"$f":"Rev_TA!K19","v":101},{"$f":"Rev_TA!L19","v":102},{"$f":"Rev_TA!M19","v":103},{"$f":"Rev_TA!N19","v":104}]
[null,null,{"$f":"Revenue_Category_2_Name","v":"Oranges"},null,null,null,null,null,null,{"$f":"Rev_TA!J20","v":101},{"$f":"Rev_TA!K20","v":102},{"$f":"Rev_TA!L20","v":103},{"$f":"Rev_TA!M20","v":104},{"$f":"Rev_TA!N20","v":105}]
[null,null,{"$f":"Revenue_Category_3_Name","v":"Bananas"},null,null,null,null,null,null,{"$f":"Rev_TA!J21","v":102},{"$f":"Rev_TA!K21","v":103},{"$f":"Rev_TA!L21","v":104},{"$f":"Rev_TA!M21","v":105},{"$f":"Rev_TA!N21","v":106}]
[null,null,{"$f":"Revenue_Category_4_Name","v":"Peaches"},null,null,null,null,null,null,{"$f":"Rev_TA!J22","v":103},{"$f":"Rev_TA!K22","v":104},{"$f":"Rev_TA!L22","v":105},{"$f":"Rev_TA!M22","v":106},{"$f":"Rev_TA!N22","v":107}]
[null,null,{"$f":"Revenue_Category_5_Name","v":"Pears"},null,null,null,null,null,null,{"$f":"Rev_TA!J23","v":104},{"$f":"Rev_TA!K23","v":105},{"$f":"Rev_TA!L23","v":106},{"$f":"Rev_TA!M23","v":107},{"$f":"Rev_TA!N23","v":108}]
[null,null,{"$f":"Revenue_Category_6_Name","v":"Plums"},null,null,null,null,null,null,{"$f":"Rev_TA!J24","v":105},{"$f":"Rev_TA!K24","v":106},{"$f":"Rev_TA!L24","v":107},{"$f":"Rev_TA!M24","v":108},{"$f":"Rev_TA!N24","v":109}]
[null,null,{"$f":"Rev_TA!C25","v":"Total"},null,null,null,null,null,null,{"$f":"SUM(J19:J24)","v":615},{"$f":"SUM(K19:K24)","v":621},627,633,639]

{"sheet":"Appendices_SC","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Appendices"]
[null,null,"Section 3."]
[null,null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Section Cover Notes:"]
[null,null,"[Insert section cover note 1]"]
[null,null,"[Insert section cover note 2]"]
[null,null,"[Insert section cover note 3]"]

{"sheet":"Lookup_Tables_SSC","index":8,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lookup Tables"]
[null,null,"Sub-Section 3.1."]
[null,null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Sub-Section Cover Notes:"]
[null,null,"[Insert sub-section cover note 1]"]
[null,null,"[Insert sub-section cover note 2]"]
[null,null,"[Insert sub-section cover note 3]"]

{"sheet":"TS_LU","index":9,"n_rows":105,"n_cols":6,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[null,"Time Series Lookup Tables"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Table of Contents"]
["é","ç","è"]
[]
[]
[null,"Time Series Lookup Tables"]
[]
[null,null,"Month Days",null,null,"Names"]
[]
[null,null,null,"Month Days",null,"LU_Mth_Days"]
[null,null,null,1]
[null,null,null,{"$f":"D12+1","v":2}]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]
[null,null,null,13]
[null,null,null,14]
[null,null,null,15]
[null,null,null,16]
[null,null,null,17]
[null,null,null,18]
[null,null,null,19]
[null,null,null,20]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[]
[null,null,"Month Names",null,null,"Names"]
[]
[null,null,null,"Month Names",null,"LU_Mth_Names"]
[null,null,null,"January"]
[null,null,null,"February"]
[null,null,null,"March"]
[null,null,null,"April"]
[null,null,null,"May"]
[null,null,null,"June"]
[null,null,null,"July"]
[null,null,null,"August"]
[null,null,null,"September"]
[null,null,null,"October"]
[null,null,null,"November"]
[null,null,null,"December"]
[]
[null,null,"Denomination",null,null,"Names"]
[]
[null,null,null,"Denomination",null,"LU_Denom"]
[null,null,null,"$Billions",null,"Billions"]
[null,null,null,"$Millions",null,"Millions"]
[null,null,null,"$'000",null,"Thousands"]
[null,null,null,"$",null,"Currency"]
[]
[null,null,"Data Term Basis",null,null,"Names"]
[]
[null,null,null,"Data Term Basis",null,"LU_Data_Term_Basis"]
[null,null,null,"Active Data Periods"]
[null,null,null,"Projections Start"]
[]
[null,null,"Periodicity",null,null,"Names"]
[]
[null,null,null,"Periodicity",null,"LU_Periodicity"]
[null,null,null,"Annual",null,"Annual"]
[null,null,null,"Semi-Annual",null,"Semi_Annual"]
[null,null,null,"Quarterly",null,"Qtrly"]
[null,null,null,"Monthly",null,"Mthly"]
[]
[null,null,"Period Type Names",null,null,"Names"]
[]
[null,null,null,"Period Type Names",null,"LU_Period_Type_Names"]
[null,null,null,"Year",null,"Yr_Name"]
[null,null,null,"Half Year",null,"Half_Yr_Name"]
[null,null,null,"Quarter",null,"Qtr_Name"]
[null,null,null,"Month",null,"Mth_Name"]
[]
[null,null,"Periods In Year",null,null,"Names"]
[]
[null,null,null,"Periods In Year",null,"LU_Pers_In_Yr"]
[null,null,null,1,null,"Yrs_In_Yr"]
[null,null,null,2,null,"Halves_In_Yr"]
[null,null,null,4,null,"Qtrs_In_Yr"]
[null,null,null,12,null,"Mths_In_Yr"]
[]
[null,null,"Conversion Factors",null,null,"Names"]
[]
[null,null,null,"Conversion Factors"]
[null,null,null,10,null,"Ten"]
[null,null,null,100,null,"Hundred"]
[null,null,null,1000,null,"Thousand"]
[null,null,null,1000000,null,"Million"]
[null,null,null,1000000000,null,"Billion"]

{"sheet":"Checks_SSC","index":10,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,2,11,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Checks"]
[null,null,"Sub-Section 3.2."]
[null,null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Sub-Section Cover Notes:"]
[null,null,"[Insert sub-section cover note 1]"]
[null,null,"[Insert sub-section cover note 2]"]
[null,null,"[Insert sub-section cover note 3]"]

{"sheet":"Checks_BO","index":11,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[null,"Checks"]
[null,{"$f":"Model_Name","v":"SMA 15. Visual Basic Programming - Best Practice Model Example"}]
[null,"Go to Table of Contents"]
["é","ç",null,"x","h","O"]
[]
[]
[null,"Error Checks"]
[]
[null,null,true]
[]
[null,null,"Errors Detected - Summary"]
[]
[null,null,null,{"$f":"D20","v":"Total Errors:"},null,null,null,null,{"$f":"Err_Chks_Ttl_Areas","v":0}]
[null,null,null,"Error Message (Empty if None):",null,null,null,null,{"$f":"IF(OR(NOT(CB_Err_Chks_Show_Msg),Err_Chks_Ttl_Areas=0),\"\",IF(Err_Chks_Ttl_Areas=1,\" (Error in \"&INDEX(CA_Err_Chks_Area_Names,MATCH(1,CA_Err_Chks_Flags,0))&\")\",\" (\"&TEXT(Err_Chks_Ttl_Areas,\"#,##0\")&\" Errors Detected)\"))","v":""}]
[]
[null,null,"Error Checks"]
[]
[null,null,null,"Error Checks",null,null,null,null,null,null,"Check","Include?","Flag"]
[]
[null,null,null,"Total Errors:",null,null,null,null,null,null,null,null,{"$f":"SUMIF(CA_Err_Chks_Inc,\"Yes\",CA_Err_Chks_Flags)","v":0}]
[]
[]
[null,"Sensitivity Checks"]
[]
[null,null,true]
[]
[null,null,"Sensitivities Detected - Summary"]
[]
[null,null,null,{"$f":"D36","v":"Total Sensitivities:"},null,null,null,null,{"$f":"Sens_Chks_Ttl_Areas","v":0}]
[null,null,null,"Sensitivity Message (Empty if None):",null,null,null,null,{"$f":"IF(OR(NOT(CB_Sens_Chks_Show_Msg),Sens_Chks_Ttl_Areas=0),\"\",IF(Sens_Chks_Ttl_Areas=1,\" (Sensitivity in \"&INDEX(CA_Sens_Chks_Area_Names,MATCH(1,CA_Sens_Chks_Flags,0))&\")\",\" (\"&TEXT(Sens_Chks_Ttl_Areas,\"#,##0\")&\" Sensitivities Detected)\"))","v":""}]
[]
[null,null,"Sensitivity Checks"]
[]
[null,null,null,"Sensitivity Checks",null,null,null,null,null,null,"Check","Include?","Flag"]
[]
[null,null,null,"Total Sensitivities:",null,null,null,null,null,null,null,null,{"$f":"SUMIF(CA_Sens_Chks_Inc,\"Yes\",CA_Sens_Chks_Flags)","v":0}]
[]
[]
[null,"Alert Checks"]
[]
[null,null,true]
[]
[null,null,"Alerts Detected - Summary"]
[]
[null,null,null,{"$f":"D52","v":"Total Alerts:"},null,null,null,null,{"$f":"Alt_Chks_Ttl_Areas","v":0}]
[null,null,null,"Alert Message (Empty if None):",null,null,null,null,{"$f":"IF(OR(NOT(CB_Alt_Chks_Show_Msg),Alt_Chks_Ttl_Areas=0),\"\",IF(Alt_Chks_Ttl_Areas=1,\" (Alert in \"&INDEX(CA_Alt_Chks_Area_Names,MATCH(1,CA_Alt_Chks_Flags,0))&\")\",\" (\"&TEXT(Alt_Chks_Ttl_Areas,\"#,##0\")&\" Alerts Detected)\"))","v":""}]
[]
[null,null,"Alert Checks"]
[]
[null,null,null,"Alert Checks",null,null,null,null,null,null,"Check","Include?","Flag"]
[]
[null,null,null,"Total Alerts:",null,null,null,null,null,null,null,null,{"$f":"SUMIF(CA_Alt_Chks_Inc,\"Yes\",CA_Alt_Chks_Flags)","v":0}]